Transcription: In this section we want to show you how to use some of the text functions. This is a category that's often overlooked by Excel users. There are many possibilities here for usage in database situations, but I think you'll see some of the examples here can be applied in any kind of an Excel worksheet environment.